In this article I am going to explain how create a database in an Android application and how create table in the database.
· Start a new project named TableDemo.
· Open res/layout/main.xml and insert the following:
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:orientation="vertical"
android:layout_width="fill_parent"
android:layout_height="fill_parent">
<TextView
android:id="@+id/txtView"
android:layout_marginLeft="100dp"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:text="@string/hello"/>
</LinearLayout>
· Open the Activity file and insert the following code:
import java.util.Locale;
import android.app.Activity;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.widget.TextView;
public class DatabaseActivity extends Activity {
private String table_name="StudentInfo";
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
SQLiteDatabase db;
// create or open database file
db = openOrCreateDatabase("Test.db" , SQLiteDatabase.CREATE_IF_NECESSARY,
null);
db.setVersion(1);
db.setLocale(Locale.getDefault());
db.setLockingEnabled(true);
// creating table in database
db.execSQL("CREATE TABLE IF NOT EXISTS "+table_name+" " +
"( sid INTEGER PRIMARY KEY AUTOINCREMENT," +
" name TEXT" +
" age INTEGER" +
" course TEXT ); ");
// capture element id from layout
TextView txtView=(TextView)findViewById(R.id.txtView);
txtView.setText("Table created");
}
}
· Run the application.
The output should look like below:
TextView display a message Table created when you run an application.
· Check the created table in the adb shell:
In order to check the tables and database information from the database, you can use adb shell provided by Android SDK:
1) Run the cmd (command prompt).
2) Go to the following location: d:\android-sdk_r13-windows\android-sdk-windows\platform-tools> (you have to user your own location).
3) Type adb shell and press enter, a # symbol will display.
4) Type sqlite3/data/data/ [package name]/databases/database-name Test.db) and press Enter.
For e.g. sqlite3 /data/data/com.android.databaseDemo/databases/Test.db
5) Then type .tables in order to see the table present in the database.
6) It will show you a list tables present in the database.
Thanks for reading this article. I think this will help you a lot.
Leave Comment